[dbo].[BAEEventGetLinkedFunctions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetLinkedFunctions

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@productCode	varchar(64)	64

SQL Script

create procedure [dbo].[BAEEventGetLinkedFunctions] @productCode varchar(64) as
SELECT p.*
    FROM Product_Sub ps
    INNER JOIN Product p on p.PRODUCT_CODE = ps.CHILD_PRODUCT_CODE
    WHERE ps.PRODUCT_CODE = @productCode

GO

Uses

[dbo].[Product]
[dbo].[Product_Sub]
dbo